<!--
  This file is a part of the open-eBackup project.
  This Source Code Form is subject to the terms of the Mozilla Public License, v. 2.0.
  If a copy of the MPL was not distributed with this file, You can obtain one at
  http://mozilla.org/MPL/2.0/.
  
  Copyright (c) [2024] Huawei Technologies Co.,Ltd.
  
  THIS SOFTWARE IS PROVIDED ON AN "AS IS" BASIS, WITHOUT WARRANTIES OF ANY KIND,
  EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO NON-INFRINGEMENT,
  MERCHANTABILITY OR FIT FOR A PARTICULAR PURPOSE.
  -->

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html lang="en-us" xml:lang="en-us">
 <head>
  <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
  <meta http-equiv="X-UA-Compatible" content="IE=edge">
  <meta name="DC.Type" content="topic">
  <meta name="DC.Title" content="What Should I Do If the Job Status Is Partially Successful During Oracle Cluster Restoration?">
  <meta name="product" content="">
  <meta name="DC.Relation" scheme="URI" content="en-us_topic_0000002164757014.html">
  <meta name="prodname" content="">
  <meta name="version" content="">
  <meta name="brand" content="">
  <meta name="DC.Publisher" content="20250306">
  <meta name="prodname" content="csbs">
  <meta name="documenttype" content="usermanual">
  <meta name="DC.Format" content="XHTML">
  <meta name="DC.Identifier" content="EN-US_TOPIC_0000002164597282">
  <meta name="DC.Language" content="en-us">
  <link rel="stylesheet" type="text/css" href="public_sys-resources/commonltr.css">
  <title>What Should I Do If the Job Status Is Partially Successful During Oracle Cluster Restoration?</title>
 </head>
 <body style="clear:both; padding-left:10px; padding-top:5px; padding-right:5px; padding-bottom:5px">
  <a name="EN-US_TOPIC_0000002164597282"></a><a name="EN-US_TOPIC_0000002164597282"></a>
  <h1 class="topictitle1">What Should I Do If the Job Status Is Partially Successful During Oracle Cluster Restoration?</h1>
  <div>
   <p>If the job status is <span class="uicontrol"><b><span><strong>Partially successful</strong></span></b></span> during Oracle cluster restoration, database restoration may fail on some hosts. In this scenario, data has been actually restored. You only need to log in to the target host on which database restoration fails and start the database according to the following procedure.</p>
   <ol>
    <li>Use PuTTY to log in to the Oracle database host.<p>You can view the target host of failed recovery jobs in the job details on the management page.</p>
     <ul>
      <li>If the Linux OS is used, use PuTTY to log in to the Oracle database host and run the <strong>su - oracle</strong> command to switch to user <strong>oracle</strong>.</li>
      <li>If the Windows OS is used, log in to the Oracle database host as the system administrator.</li>
     </ul></li>
    <li>Run the following commands to log in to the Oracle database instance.
     <ul>
      <li id="EN-US_TOPIC_0000002164597282__en-us_topic_0000002164597290_li15682124913711">OS authentication:
       <ul id="EN-US_TOPIC_0000002164597282__en-us_topic_0000002164597290_ul89443983816">
        <li id="EN-US_TOPIC_0000002164597282__en-us_topic_0000002164597290_li18420124173415">If the Linux OS is used, run the following commands:<p id="EN-US_TOPIC_0000002164597282__en-us_topic_0000002164597290_p95148598366"><a name="EN-US_TOPIC_0000002164597282__en-us_topic_0000002164597290_li18420124173415"></a><a name="en-us_topic_0000002164597290_li18420124173415"></a><strong id="EN-US_TOPIC_0000002164597282__en-us_topic_0000002164597290_b14236563719">export ORACLE_SID=</strong><em id="EN-US_TOPIC_0000002164597282__en-us_topic_0000002164597290_i85144598369">Database instance name</em></p> <p id="EN-US_TOPIC_0000002164597282__en-us_topic_0000002164597290_p145141259153613"><strong id="EN-US_TOPIC_0000002164597282__en-us_topic_0000002164597290_b1597618293715">sqlplus / as sysdba</strong></p></li>
        <li id="EN-US_TOPIC_0000002164597282__en-us_topic_0000002164597290_li7402151163816">If the Windows OS is used, perform the following operations:
         <ol type="a" id="EN-US_TOPIC_0000002164597282__en-us_topic_0000002164597290_ol124110408264">
          <li id="EN-US_TOPIC_0000002164597282__en-us_topic_0000002164597290_li624120402267">Press <span class="uicontrol" id="EN-US_TOPIC_0000002164597282__en-us_topic_0000002164597290_en-us_topic_0000002164597290_uicontrol11819941114510"><b>Win+R</b></span> to open the <strong id="EN-US_TOPIC_0000002164597282__en-us_topic_0000002164597290_en-us_topic_0000002164597290_b1015191219408">Run</strong> window.</li>
          <li id="EN-US_TOPIC_0000002164597282__en-us_topic_0000002164597290_li161821338277">Enter <span class="parmvalue" id="EN-US_TOPIC_0000002164597282__en-us_topic_0000002164597290_parmvalue122291222476"><b>cmd</b></span> and run the following commands:<p id="EN-US_TOPIC_0000002164597282__en-us_topic_0000002164597290_p1755152313372"><strong id="EN-US_TOPIC_0000002164597282__en-us_topic_0000002164597290_b19591532143713">set ORACLE_SID=</strong><em id="EN-US_TOPIC_0000002164597282__en-us_topic_0000002164597290_i16755423133718">Database instance name</em></p> <p id="EN-US_TOPIC_0000002164597282__en-us_topic_0000002164597290_p1075515234379"><strong id="EN-US_TOPIC_0000002164597282__en-us_topic_0000002164597290_b540852910371">sqlplus / as sysdba</strong></p></li>
         </ol></li>
       </ul></li>
      <li id="EN-US_TOPIC_0000002164597282__en-us_topic_0000002164597290_li105571236103417">Database authentication:
       <ul id="EN-US_TOPIC_0000002164597282__en-us_topic_0000002164597290_ul1136516538386">
        <li id="EN-US_TOPIC_0000002164597282__en-us_topic_0000002164597290_li1723334817382">If the Linux OS is used, run the following commands:<p id="EN-US_TOPIC_0000002164597282__en-us_topic_0000002164597290_p920984963717"><a name="EN-US_TOPIC_0000002164597282__en-us_topic_0000002164597290_li1723334817382"></a><a name="en-us_topic_0000002164597290_li1723334817382"></a><strong id="EN-US_TOPIC_0000002164597282__en-us_topic_0000002164597290_b162511338427">export ORACLE_SID=</strong><em id="EN-US_TOPIC_0000002164597282__en-us_topic_0000002164597290_i142521037423">Database instance name</em></p> <p id="EN-US_TOPIC_0000002164597282__en-us_topic_0000002164597290_p182093496371"><strong id="EN-US_TOPIC_0000002164597282__en-us_topic_0000002164597290_b034785743716">sqlplus</strong></p> <p id="EN-US_TOPIC_0000002164597282__en-us_topic_0000002164597290_p17915722412">Enter the name of a user with the <strong id="EN-US_TOPIC_0000002164597282__en-us_topic_0000002164597290_b0440649114212">sysdba</strong> permissions as prompted:</p> <pre class="screen" id="EN-US_TOPIC_0000002164597282__en-us_topic_0000002164597290_screen9915112104114"><em id="EN-US_TOPIC_0000002164597282__en-us_topic_0000002164597290_i1915102164113">username </em>as sysdba</pre> <p id="EN-US_TOPIC_0000002164597282__en-us_topic_0000002164597290_p159150224117">Enter the password as prompted.</p></li>
        <li id="EN-US_TOPIC_0000002164597282__en-us_topic_0000002164597290_li122822426407">If the Windows OS is used, perform the following operations:
         <ol type="a" id="EN-US_TOPIC_0000002164597282__en-us_topic_0000002164597290_ol587720252273">
          <li id="EN-US_TOPIC_0000002164597282__en-us_topic_0000002164597290_li5168124414479">Press <span class="uicontrol" id="EN-US_TOPIC_0000002164597282__en-us_topic_0000002164597290_en-us_topic_0000002164597290_uicontrol11819941114510_1"><b>Win+R</b></span> to open the <strong id="EN-US_TOPIC_0000002164597282__en-us_topic_0000002164597290_en-us_topic_0000002164597290_b1015191219408_1">Run</strong> window.</li>
          <li id="EN-US_TOPIC_0000002164597282__en-us_topic_0000002164597290_li3877172517270">Enter <span class="parmvalue" id="EN-US_TOPIC_0000002164597282__en-us_topic_0000002164597290_parmvalue89061315114212"><b>cmd</b></span> and run the following commands:<p id="EN-US_TOPIC_0000002164597282__en-us_topic_0000002164597290_p8745723103813"><strong id="EN-US_TOPIC_0000002164597282__en-us_topic_0000002164597290_b0361183517422">set ORACLE_SID=</strong><em id="EN-US_TOPIC_0000002164597282__en-us_topic_0000002164597290_i8361163518426">Database instance name</em></p> <p id="EN-US_TOPIC_0000002164597282__en-us_topic_0000002164597290_p15745182333814"><strong id="EN-US_TOPIC_0000002164597282__en-us_topic_0000002164597290_b11154427163811">sqlplus</strong></p> <p id="EN-US_TOPIC_0000002164597282__en-us_topic_0000002164597290_p71274192512">Enter the name of a user with the <strong id="EN-US_TOPIC_0000002164597282__en-us_topic_0000002164597290_b330420012221">sysdba</strong> permissions as prompted:</p> <pre class="screen" id="EN-US_TOPIC_0000002164597282__en-us_topic_0000002164597290_screen18896121620243"><em id="EN-US_TOPIC_0000002164597282__en-us_topic_0000002164597290_i380114413256">username </em>as sysdba</pre> <p id="EN-US_TOPIC_0000002164597282__en-us_topic_0000002164597290_p15251105852511">Enter the password as prompted.</p></li>
         </ol></li>
       </ul></li>
     </ul></li>
    <li>Run the following command to start the database:<p><strong>startup;</strong></p></li>
   </ol>
  </div>
  <div>
   <div class="familylinks">
    <div class="parentlink">
     <strong>Parent topic:</strong> <a href="en-us_topic_0000002164757014.html">FAQs</a>
    </div>
   </div>
  </div>
 </body>
</html>